ALTER VIEW [dbo].[View_FW_BuUnit]
AS
SELECT  BuUnitNewGUID,
         BuUnitName,
         BuUnitCode,
         BuUnitWebSiteUrl,
         BuUnitFax,
         BuUnitAddress,
         BuUnitLegalPerson,
         BuUnitRemark,
         IsCompanyBuUnit,
         TenantId,
         IsDeleted,
         CreateTime,
         CreateGUID,
         CreatedName,
         ModifiedTime,
         ModifiedGUID,
         ModifiedName,
         ApproveState,
         ApproveGUID,
         ApproveTime,
         ParentGUID,
         FullCode,
         OrderCode,
		 BuUnitGUID,
         Icon,
		 CompanyGUID
FROM dbo.FW_BuUnit